fda71f38b52fd2582a5e7fadaff772fa8c5ba14f,src/main/java/com/continuuity/passport/dal/db/AccountDBAccess.java,AccountDBAccess,createAccount,#Account#,38
Before Change
throw new ConfigurationException("DBConnection pool is null. DAO is not configured");
}
try {
Connection connection= this.poolManager.getConnection();
String SQL = String.format( "INSERT INTO %s (%s, %s, %s, %s, %s, %s) VALUES (?,?,?,?,?,?)",
DBUtils.AccountTable.TABLE_NAME,
DBUtils.AccountTable.EMAIL_COLUMN, DBUtils.AccountTable.FIRST_NAME_COLUMN,
DBUtils.AccountTable.LAST_NAME_COLUMN, DBUtils.AccountTable.COMPANY_COLUMN,
DBUtils.AccountTable.CONFIRMED_COLUMN, DBUtils.AccountTable.ACCOUNT_CREATED_AT
);
PreparedStatement ps = connection.prepareStatement(SQL, Statement.RETURN_GENERATED_KEYS);
ps.setString(1, account.getEmailId());
ps.setString(2,account.getFirstName());
ps.setString(3,account.getLastName());
ps.setString(4, account.getCompany());
ps.setInt(5, DBUtils.AccountTable.ACCOUNT_UNCONFIRMED);
ps.setTimestamp(6, new java.sql.Timestamp(System.currentTimeMillis()));
ps.executeUpdate();
ResultSet result = ps.getGeneratedKeys();
if (result == null) {
throw new RuntimeException("Failed Insert");
}
After Change
throw new ConfigurationException("DBConnection pool is null. DAO is not configured");
}
try {
connection= this.poolManager.getConnection();
String SQL = String.format( "INSERT INTO %s (%s, %s, %s, %s, %s, %s) VALUES (?,?,?,?,?,?)",
DBUtils.AccountTable.TABLE_NAME,
DBUtils.AccountTable.EMAIL_COLUMN, DBUtils.AccountTable.FIRST_NAME_COLUMN,
DBUtils.AccountTable.LAST_NAME_COLUMN, DBUtils.AccountTable.COMPANY_COLUMN,
DBUtils.AccountTable.CONFIRMED_COLUMN, DBUtils.AccountTable.ACCOUNT_CREATED_AT
);
ps = connection.prepareStatement(SQL, Statement.RETURN_GENERATED_KEYS);
ps.setString(1, account.getEmailId());
ps.setString(2,account.getFirstName());
ps.setString(3,account.getLastName());
ps.setString(4, account.getCompany());
ps.setInt(5, DBUtils.AccountTable.ACCOUNT_UNCONFIRMED);
ps.setTimestamp(6, new java.sql.Timestamp(System.currentTimeMillis()));
ps.executeUpdate();
result = ps.getGeneratedKeys();
if (result == null) {
throw new RuntimeException("Failed Insert");
}